Commonly Used MDS Reports

The most commonly used sales reports for store and head office reporting in MDS are:

Report	Frequency	Timing	Refer to this topic
System Summary - a snapshot of your Distribution System (sales, debtors Aged Trial Balance, stock movements, Stock on Hand)	As required	As required	"Sales Desk Inquiries - System Summary"
Debtors Aged Trial Balance	As required	As required	"Debtor Reports - Aged Trial Balance" "Debtor Reports - Aged Trial Balance with Transactions" "Debtor Reports - Aged Trial Balance Total"
Daily Sales Register (all invoices, credit notes and debtor journals for the current day)	Daily	End of day	"Sales Desk Reports - Daily Sales Register"
Monthly Sales Register (all invoices, credit notes and debtor journals for the current month)	Monthly	End of month	"Sales Desk Reports - Monthly Sales Register"
Product Category Sales Report (sales by product category)	As required	As required	"Other Reports - Category Report"
Sales Territory Sales Report (sales by sales territory)	As required	As required	"Other Reports - Sales Territory Report"
Sales by Sales Territory by Category Report (MTD and YTD totals by sales territory)	As required	As required	"Sales Report - Sales by Territory by Category"
Sales Reports (sales history by salesperson, by salesperson by category, or MTD and YTD)	As required	As required	"Salesperson Reports - Sales Report"
Top Item Sales (top or bottom selling items by various parameters)	As required	As required	"Inventory Reports - Top Item Sales"

The most commonly used goods received and stock reports for store and head office reporting in MDS are:

Report	Frequency	Timing	Refer to this topic
Inventory Valuation Report (Stock on Hand by quantity and cost value)	As required	As required	"Inventory Reports - Valuation Report"
On Order Report (outstanding purchase orders by supplier)	As required	As required	"Purchasing Reports - On Order Report"
Uncosted Report (outstanding delivery dockets by supplier that have not yet been reconciled against an invoice)	As required	As required	"Purchasing Reports - Uncosted Report"
Goods Received Report (all goods received through the Goods Receipt program in Micronet since the last time the report was printed)	As required	As required	"Goods Received - File - Goods Received Report "
Sales History Inquiry - Item (all sales of an item)	As required	As required	"History - Sales"
Purchase History Inquiry - Item (all purchases of an item)	As required	As required	"History - Purchase"
Picking Slip Inquiry (all picking slips on which an item is included)	As required	As required	"Dissection - Picking Slip"
Held Items in POS Inquiry (goods to be delivered to customers and due dates for delivery)	As required	As required	"Dissection - Pos Docket"
Purchase Order Inquiry - Item (outstanding purchase orders on which an item is included)	As required	As required	"Dissection - Purchase Order"